<?php
session_start();
   if($_SESSION['adm'] != true) { header("Location:estagiobuscaconfimpre.php"); }
?>
<?php include ("class.php"); ?>
<?php
   $filCurso="";
  if ($_GET["coCurso"] != "")
  {
    $filCurso = " and co_curso = ". intval($_GET["coCurso"]). "  ";
  }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Est&aacute;gio SESC</title>
<link href="css/estagio.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body,td,th {
	font-family: Arial, Helvetica, sans-serif;
}
body {
	background-color: #FFFFFF;
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style>
</head>

<body>
<table width="759" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div align="center"><img src="imagens/estagiologo.gif" alt="Est&aacute;gio SESC" width="233" height="65" /></div></td>
  </tr>
  <tr>
    <td class="Titulo">&nbsp;</td>
  </tr>
  <tr>
    <td class="Titulo"><p>Validar candidatos para entrevista  - Est&aacute;gio 2006</p>    </td>
  </tr>
  <tr>
    <td class="txtCorpo"><div align="center"></div></td>
  </tr>
  <tr>
    <td class="DestaqueCurso">Filtrar por curso: 
      <label>
      <select name="coCurso" onchange="top.location='valida_para_entrevista.php?coCurso=' + this.value + ''">
	    <option value="">Todos</option>
	    <?php $All->fselectCurso(intval($_GET["coCurso"])); ?>
      </select>
    </label></td>
  </tr>
  <tr>
    <td class="txtCorpo">&nbsp;</td>
  </tr>
   <tr>
    <td class="Titulo">Candidatos que realizaram a prova sem confirma&ccedil;&atilde;o para entrevista </td>
  </tr>
  <tr>
    <td class="txtCorpo"><table width="100%" border="0" cellpadding="1" cellspacing="1">
      <tr>
	    <td class="DestaqueCurso">Aprovar</td>
        <td width="9%" class="SubTitulo">C&oacute;digo</td>
        <td width="55%" class="SubTitulo">Nome</td>
        <td width="11%" class="SubTitulo">RG</td>
        <td width="19%" class="SubTitulo">CPF</td>
        <td width="6%" class="SubTitulo">Nota</td>
      </tr>
      <?php
         $s="Select *, UCASE(nome) as nome from tab_cadastrados where nome <> '' and st_confirmacao='S' and st_aprovado='N' ". $filCurso . "Order By UCASE(trim(nome))";
		 $q=mysql_query($s) or die(mysql_error());
		 while($r= mysql_fetch_object($q))
		 {
		  $bg == "#d3d3d3" ? $bg="#e7e7e7" : $bg="#d3d3d3";
		 
	  ?>
      <tr style="background:<?php echo  $bg; ?>">
        <td class="DestaqueCurso"><?php echo  $All->linkValidarParaEntrevista($r->co_cadastrado,$_GET['coCurso']); ?></td>
		 <td class="DestaqueCurso"><?php echo  $r->co_cadastrado; ?></td>
        <td class="txtCorpo"><?php echo  $r->nome; ?></td>
        <td class="txtCorpo"><?php echo  $r->numero_rg; ?></td>
        <td class="txtCorpo"><?php echo  $r->cpf; ?></td>
        <td class="txtCorpo"><?php echo  $r->np; ?></td>
      </tr>
      <?php } ?>

      <tr>
        <td colspan="6" class="SubTitulo">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td class="txtCorpo">&nbsp;</td>
  </tr>
  <tr>
    <td class="Titulo">Candidatos confirmados para entrevista </td>
  </tr>
  <tr>
    <td class="txtCorpo"><table width="100%" border="0" cellpadding="1" cellspacing="1">
      <tr>
        <td width="9%" class="SubTitulo">C&oacute;digo</td>
        <td width="55%" class="SubTitulo">Nome</td>
        <td width="11%" class="SubTitulo">RG</td>
        <td width="19%" class="SubTitulo">CPF</td>
        <td width="6%" class="SubTitulo">Nota</td>
      </tr>
      <?php
         $s="Select *, UCASE(nome) as nome from tab_cadastrados where nome <> '' and st_confirmacao='S' and st_aprovado='S' ". $filCurso . "Order By UCASE(trim(nome))";
		 $q=mysql_query($s) or die(mysql_error());
		 while($r= mysql_fetch_object($q))
		 {
		  $bg == "#d3d3d3" ? $bg="#e7e7e7" : $bg="#d3d3d3";
		 
	  ?>
      <tr style="background:<?php echo  $bg; ?>">
        <td class="DestaqueCurso"><?php echo  $r->co_cadastrado; ?></td>
        <td class="txtCorpo"><?php echo  $r->nome; ?></td>
        <td class="txtCorpo"><?php echo  $r->numero_rg; ?></td>
        <td class="txtCorpo"><?php echo  $r->cpf; ?></td>
        <td class="txtCorpo"><?php echo  $r->np; ?></td>
      </tr>
      <?php } ?>
      <tr>
        <td width="9%" class="SubTitulo">&nbsp;</td>
        <td width="55%" class="SubTitulo">&nbsp;</td>
        <td width="11%" class="SubTitulo">&nbsp;</td>
        <td width="19%" class="SubTitulo">&nbsp;</td>
        <td width="6%" class="SubTitulo">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="5" class="SubTitulo">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td class="txtCorpo">&nbsp;</td>
  </tr>
</table>
</body>
</html>
